﻿<!DOCTYPE html>
<html>
	<head>
		<title>Add cell background and borders</title>
		<meta charset="utf-8" />
		<meta name="description" content="Adjust the cell style by adding the cell background and borders" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
			<h1>Add cell background and borders</h1>            
            <h3>Add a cell background</h3>
            <p>To apply and format a cell background in the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a>,</p>
            <ol>
                <li>
                    select a cell or a cell range with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination,
                    <p class="note"><b>Note</b>: you can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
                </li>
                <li>to apply a <em>solid color</em> fill to the cell background, click the <b>Background color</b> <div class = "icon icon-backgroundcolor"></div> icon on the <b>Home</b> tab of the top toolbar and choose the required color. 
                </li>
                <li>to use other fill types, such as a <em>gradient</em> fill or <em>pattern</em>, click the <b>Cell settings</b> <div class = "icon icon-cellsettings_rightpanel"></div> icon on the right sidebar and use the <b>Fill</b> section:
                    <ul>
                        <li>
                            <b>Color Fill</b> - select this option to specify the solid color you want to fill the selected cells with.
                            <p><img alt="Color Fill" src="../images/cell_fill_color.png" /></p>
                            <p id="color">Click the colored box below and select one of the following palettes:</p>
                            <p><img alt="Palette" src="../images/palette.png" /></p>
                            <ul>
                                <li><b>Theme Colors</b> - the colors that correspond to the selected color scheme of the spreadsheet.</li>
                                <li><b>Standard Colors</b> - a set of default colors. The selected color scheme does not affect them.</li>
                                <li>
                                    You can also apply a <b>custom color</b> using two different options:
                                    <ul>
                                        <li>
                                            <b>Eyedropper</b> - use this option to choose the required color by clicking it in the spreadsheet.
                                        </li>
                                        <li>
                                            <b>More colors</b> - click this caption if the required color is missing among the available palettes. Select the necessary color range moving the vertical color slider and set a specific color dragging the color picker within the large square color field. Once you select a color with the color picker, the appropriate RGB and sRGB color values will be displayed in the fields on the right. You can also define a color on the base of the RGB color model by entering the corresponding numeric values into the <b>R</b>, <b>G</b>, <b>B</b> (red, green, blue) fields or enter the sRGB hexadecimal code into the field marked with the <b>#</b> sign. The selected color appears in the <b>New</b> preview box. If the object was previously filled with any custom color, this color is displayed in the <b>Current</b> box so you can compare the original and modified colors. When the color is defined, click the <b>Add</b> button:
                                            <p><img alt="Palette - Custom Color" src="../../../../../../common/main/resources/help/en/images/palette_custom.png" /></p>
                                            <p>The custom color will be applied to the selected element and added to the <b>Recent colors</b> palette.</p>
                                        </li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li>
                            <b>Gradient Fill</b> - fill the selected cells with two colors which smoothly change from one to the other.
                            <p><img alt="Gradient Fill" src="../images/cell_fill_gradient.png" /></p>
                            <ul>
                                <li><b>Angle</b> - manually specify an exact value in degrees that defines the gradient direction (colors change in a straight line at the specified angle).</li>
                                <li><b>Direction</b> - choose a predefined template from the menu. The following directions are available: top-left to bottom-right (<em>45&deg;</em>), top to bottom (<em>90&deg;</em>), top-right to bottom-left (<em>135&deg;</em>), right to left (<em>180&deg;</em>), bottom-right to top-left (<em>225&deg;</em>), bottom to top (<em>270&deg;</em>), bottom-left to top-right (<em>315&deg;</em>), left to right (<em>0&deg;</em>).</li>
                                <li>
                                    <b>Gradient Point</b> is a specific point for transition from one color to another.
                                    <ul>
                                        <li>Use the <div class = "icon icon-addgradientpoint"></div> <b>Add Gradient Point</b> button or slider bar to add a gradient point. You can add up to 10 gradient points. Each next gradient point added will in no way affect the current gradient fill appearance. Use the <div class = "icon icon-removegradientpoint"></div> <b>Remove Gradient Point</b> button to delete a certain gradient point.</li>
                                        <li>Use the slider bar to change the location of the gradient point or specify <b>Position</b> in percentage for precise location.</li>
                                        <li>To apply a color to a gradient point, click a point on the slider bar, and then click <b>Color</b> to choose the color you want.</li>
                                    </ul>
                                </li>
                            </ul>
                        </li>
                        <li>
                            <b>Pattern</b> - select this option to fill the selected cells with a two-colored design composed of regularly repeated elements.
                            <p><img alt="Pattern Fill" src="../images/cell_fill_pattern.png" /></p>
                            <ul>
                                <li><b>Pattern</b> - select one of the predefined designs from the menu.</li>
                                <li><b>Foreground color</b> - click this color box to change the color of the pattern elements.</li>
                                <li><b>Background color</b> - click this color box to change the color of the pattern background.</li>
                            </ul>
                        </li>
                        <li><b>No Fill</b> - select this option if you don't want to use any fill.</li>
                    </ul>
                </li>
            </ol>
                        
            <h3 id="cell_borders">Add cell borders</h3>
			<p>To add and format borders to a worksheet,</p>
			<ol>
				<li>select a cell, a range of cells with the mouse or the whole worksheet by pressing the <b>Ctrl+A</b> key combination,
                <p class="note"><b>Note</b>: you can also select multiple non-adjacent cells or cell ranges holding down the <b>Ctrl</b> key while selecting cells/ranges with the mouse.</p>
                </li>
				<li>click the <b>Borders</b> <div class = "icon icon-addborders"></div> icon on the <b>Home</b> tab of the top toolbar or click the <b>Cell settings</b> <div class = "icon icon-cellsettings_rightpanel"></div> icon on the right sidebar and use the <b>Borders Style</b> section,
                <p><img alt="Cell settings tab" src="../images/cellsettingstab.png" /></p>
                </li>
				<li>select the border style you wish to apply: 
                <ol>
                    <li>open the <b>Border Style</b> <div class = "icon icon-borderstyle"></div> submenu and select one of the available options, </li>
                    <li>open the <b>Border Color</b> <div class = "icon icon-bordercolor"></div> icon submenu or use the <b>Color</b> palette on the right sidebar and select the required color from the palette,</li>
                    <li>select one of the available border templates: <b>Outside Borders</b> <div class = "icon icon-outsideborders"></div>, <b>All Borders</b> <div class = "icon icon-allborders"></div>, <b>Top Borders</b> <div class = "icon icon-topborders"></div>, <b>Bottom Borders</b> <div class = "icon icon-bottomborders"></div>, <b>Left Borders</b> <div class = "icon icon-leftborders"></div>, <b>Right Borders</b> <div class = "icon icon-rightborders"></div>, <b>No Borders</b> <div class = "icon icon-noborders"></div>, <b>Inside Borders</b> <div class = "icon icon-insideborders"></div>, <b>Inside Vertical Borders</b> <div class = "icon icon-insideverticalborders"></div>, <b>Inside Horizontal Borders</b> <div class = "icon icon-insidehorizontalborders"></div>, <b>Diagonal Up Border</b> <div class = "icon icon-diagonal_up_border"></div>, <b>Diagonal Down Border</b> <div class = "icon icon-diagonal_down_border"></div>.</li>
                </ol>
                </li>
			</ol>
		</div>
	</body>
</html>
